//package com.waste.game.mapper;
//
//import com.waste.game.entity.*;
//import io.swagger.models.auth.In;
//import org.apache.ibatis.annotations.*;
//
//import java.util.List;
//
//@Mapper
//public interface WebServeMapper {
//
//    @Insert("INSERT INTO web_suggest VALUES(NULL,#{suggest})")
//    void insert(SuggestBean suggestBean);
//
//    @Update("UPDATE gameall SET game_look=#{gameLook} WHERE id=#{id}")
//    void lookUp(Integer gameLook,Integer id);
//
//    @Select("SELECT game_look FROM gameall WHERE id=#{id}")
//    Integer selectLOOK(Integer id);
//
//    @Update("UPDATE gameall SET game_download=#{gameDownload} WHERE id=#{id}")
//    void DownUp(Integer gameDownload,Integer id);
//
//    @Select("SELECT game_download FROM gameall WHERE id=#{id}")
//    Integer selectDown(Integer id);
//    //
//    @Select("SELECT id,article_id,visitorName,commentContent,type,aite,userImg,addTime,parent_id,user_id FROM game_pl WHERE article_id = #{id}" +
//            " AND parent_id IS NULL and type=1 ORDER BY addTime")
//    List<UserPlBean> getPl(Integer id);
//    //根据时间查询评论
//    @Select("SELECT p.id,p.article_id,p.visitorName,p.type,p.commentContent,p.aite,p.addTime,p.parent_id,p.user_id,p.admin_type,o.user_lIke_num,o.like_user_my," +
//            "i.user_img FROM game_pl p,user_like_one o,game_pl_img i WHERE article_id = #{id} AND p.id = o.id AND p.userImg = i.id ORDER BY addTime DESC")
//    List<UserPlBean> getPlOne(Integer id);
//    //根据点赞查询评论
//    @Select("SELECT p.id,p.article_id,p.visitorName,p.type,p.commentContent,p.aite,p.addTime,p.parent_id,p.user_id,p.admin_type,o.user_lIke_num,o.like_user_my," +
//            "i.user_img FROM game_pl p,user_like_one o,game_pl_img i WHERE article_id = #{id} AND p.id = o.id AND p.userImg = i.id ORDER BY user_lIke_num DESC")
//    List<UserPlBean> getHotPlOne(Integer id);
//    //被举报评论查询
//    @Select("SELECT p.id,p.article_id,p.visitorName,p.commentContent FROM game_pl p,game_pl_jb j WHERE p.id=j.bjb_id")
//    List<UserPlBean> getPlBack();
//    //被举报评论插入
//    @Insert("INSERT INTO game_pl_jb VALUES(NULL,#{id})")
//    boolean jbUp(Integer id);
//
//    //评论插入
//    @Insert("INSERT INTO game_pl VALUES(NULL,#{articleId},#{visitorName},#{userEmail},#{commentContent},#{addTime},#{parentId},null,#{type},#{aite},#{userImg},#{adminType},#{hf})")
//    void insertPl(UserPlBean userPlBean);
//    //点赞插入
//    @Insert("INSERT INTO user_like_one VALUES(null,0,null,null)")
//    void insertLike();
//    //点赞修改(暂定)
//    @Update("UPDATE user_like_one SET user_lIke_num = user_lIke_num + 1 WHERE id = #{id}")
//    void upLikeOne(Integer id);
//    //点赞修改(暂定)
//    @Update("UPDATE user_like_one SET user_lIke_num = user_lIke_num - 1 WHERE id = #{id}")
//    void deLikeOne(Integer id);
//    //轮播图查询
////    @Select("SELECT * FROM game_lbt")
////    List<LbtBean> getLbt();
//    //普通eom
//    @Select("SELECT eom_ico,id FROM game_pl_bq WHERE ico_type = 'eom'")
//    List<EomBean> getEomPT();
//    //普通颜文字
//    @Select("SELECT eom_ico,id FROM game_pl_bq WHERE ico_type = 'ywz'")
//    List<EomBean> getYWZPT();
//    //哔哩哔哩eom
//    @Select("SELECT eom_ico,id FROM game_pl_bq WHERE ico_type = 'bilieom'")
//    List<EomBean> getBILIEom();
//    //哔哩哔哩文字
//    @Select("SELECT eom_ico,id FROM game_pl_bq WHERE ico_type = 'bilifont'")
//    List<EomBean> getBILIWz();
//    //查询评论名
//    @Select("SELECT id FROM game_pl WHERE aite = #{name} and article_id = #{id}")
//    List<UserPlBean> getCXName(String name,Integer id);
//
//    //添加评论被举报id
//    @Insert("INSERT INTO game_pl_jb VALUES(NULL,#{id})")
//    boolean instPlJb(Integer id);
//    //安装教程查询
//    @Select("SELECT inst_img,inst_url,inst_type FROM game_inst JOIN game_inst_aut on art_id = #{id} AND game_inst_aut.inst_type2 = game_inst.id")
//    List<InstJcBean> getJc(Integer id);
//    //轮播图查询
//    @Select("SELECT lbt_img,art_id,lbt_title,lbt_img_sm FROM game_lbt LIMIT 6")
//    List<LbtBean> getLbt();
//
//    //轮播图修改查询
//    @Select("SELECT id,lbt_img,art_id,lbt_title,lbt_img_sm FROM game_lbt WHERE art_id = #{id}")
//    LbtBean getLbtOne(Integer id);
//    //轮播图修改
//    @Update("UPDATE game_lbt SET lbt_img = #{lbtImg},lbt_title=#{lbtTitle},lbt_img_sm = #{lbtImgSm},art_id =#{artId} WHERE id=#{id}")
//    Boolean editLbt(LbtBean lbtBean);
//    //修改网站主题壁纸
//    @Update("UPDATE game_lbt SET lbt_img = #{webImg} WHERE id=7")
//    boolean editBackground(LbtBean lbtBean);
//
//    //@我评论查询
//    @Select("SELECT id,visitorName,commentContent,article_id FROM game_pl WHERE hf= 0 AND aite = '@暮迟'")
//    List<UserPlBean> getaite();
//    //评论列表
//    @Select("SELECT id,visitorName,commentContent,article_id FROM game_pl")
//    List<UserPlBean> getplindex();
//
//    //删除评论
//    @Delete("DELETE FROM game_pl WHERE id=#{id}")
//    boolean delpl(Integer id);
//
//    //安装教程插入
//    @Insert("INSERT INTO game_inst(inst_img,inst_url,inst_type)VALUES(#{instImg},#{instUrl},#{instType})")
//    boolean upInst(InstJcBean instJcBean);
//
//    //安装列表查询
//    @Select("SELECT inst_type,id FROM game_inst")
//    List<InstJcBean> getInstList();
//
//    //安装教程链接插入
//    @Insert("INSERT INTO game_inst_aut(art_id,inst_type2)VALUES(#{id},#{type})")
//    boolean instaut(Integer type,Integer id);
//
//    @Update("UPDATE game_user SET user_password = #{pass} WHERE user_id = 1")
//    boolean instpass(String pass);
//}
